MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Club Membership (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 132KB | 1,042 lines

Field Trip Summary Open Script HBAM2016AUG95 Pro 3.0 HBAM3016AUG95@ Pro 2.0 - 2.1F! Pro 3.0 Pro 3.0 Pro 3.0 Pro 3.0 Pro 3.0 BUS CITY BUS NAME d BUS PHONE j BUS STATE BUS STREET BUS ZIP CODE COUNTRY CREATED BY DATE BIRTH DATE CREATED DATE INITIATED DATE MEMBERSHIP TERMINATED DATE MODIFIED DATE OF ANNIVERSARY DATE OF LAST DUES CYCLE DATE OF LAST PAYMENT DATE OF NEXT DUES CYCLE DATE OF THIS DUES CYCLE DUES ARE LATE ~ DUES PAID EMAIL ADDRESS FIRST NAME X HOME CITY HOME PHONE HOME STATE HOME STREET HOME ZIP CODE LAST LAYOUT LAST NAME W MEMBER ID MIDDLE NAME NOTES OFFICER OFFICES HELD REFERRED BY SPOUSE'S NAME YEARS OF MEMBERSHIP Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Form View - Membership A List View Information Report Menu Member Phone List Form View - Personal Form View - MembershipB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter A Member IDB Date CreatedB Date ModifiedB WA Last NameB First NameB Home StreetB `A Home CityB Home StateB X1The state field should only contain 2 characters. a ) = 2 ) a ) ) Home ZIP CodeB Middle NameB Bus NameB Bus StreetB Bus CityB gA Bus StateB X1The state field should only contain 2 characters. g ) = 2 ) g ) ) Bus ZIP CodeB Home PhoneB jA Bus PhoneB Date InitiatedB Referred ByB Date BirthB CountryB Date of AnniversaryB Spouse's NameB Date Membership TerminatedB Offices HeldB OfficerB NotesB Date of Last PaymentB Date of Next Dues CycleB b) + 1 Date of This Dues CycleB }A Dues PaidB "No" "Yes") Dues Are LateB "No" "Yes" "No")) Date of Last Dues CycleB b) - 1 Years of MembershipB EMail AddressB InfoB Created ByB Last LayoutB Description Use this file to manage club membership information. Easily keep track of when member's renewal fees are due. How to use this solution Use the Membership and Personal tabs to enter and view information about the current member. You can view and print a report of members' phone numbers. How to customize this solution Create reports that list members by start date or by company. Add email to the Phone Numbers report. Create a layout that reminds you of upcoming birthdays or B anniversaries. You can simply find all birthdays in the coming month and display them in a report. Or, you can add a calculation field that compares today's date against the birth date and then create a report of all birthdays in the next 30 days. u) - l) / 365)) A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Offices Held Current Office Referred By Years of Membership Termination Initiation Notes Overdue? Paid Yet? Date of Last Payment Current Cycle Member ID Last Name First Name (Enter Membership Information for Members Membership Personal InformationB Yesfter Noarter \*Click to see more information for a Member] Late?^ Paid?_ Last Payment` Home Phonea Last Nameb First NameT \*Click to see more information for a Member] Late?^ Paid?_ Last Payment` Home Phonea Last Nameb First Name Your Own Buttond Your Own Buttone Recordf Delete Recordg Recordh Reportsi View As Listj View As Formk Closel Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Club Membership solutionP Info for this Solution out the Club Membership solutionP Info for this Solution Your Own ButtonB ReportsC View As ListD View As FormE CloseF InfoG Your Own ReportH Your Own ReportI Your Own ReportJ Member Phone ListK>Click on any of these buttons to preview the respective reportL Select a report ReportH Your Own ReportI Your Own ReportJ Member Phone ListK>Click on any of these buttons to preview the respective reportL Select a report Member Phone ListB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF Form View - PersonalB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Bus. Phone Business Home Phone t Last Name First Name Page ## Member Phone List Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Anniversary Spouse's Name Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Anniversary Spouse's Name Birthday Bus Phone E-Mail Home Phone ZIP Code Address Business Country ZIP Code Address Member ID Last Name First Name &Enter Personal Information for Members Membership Personal 11/20/95 Davidson Julie 839 Eighth Ave. Foster City 94401 Smith & Waterman 2222 East Rainfall Boulder Creek 95006 415-555-0900 408-555-8181 04/03/94 5/1/62 4/4/94 t Jack Long 06/07/95 12/1/95 11/1/95 10/1/95 julie_davidson@sw.com 11/20/95 Pamela 466 West Ave. Eckman 24829 West End Corporation 700 Battle Rd. 24828 712-555-5245 712-555-7396 11/02/92 9/21/61 President, Founder 05/03/95 12/1/95 11/1/95 10/1/95 pamela_day@westend.com 01450 Norris Corporation 690 Compton Pl. Concord 01742 508-555-6899 508-555-9900 05/03/94 Julie Davidson 05/07/95 11/1/95 10/1/95 9/1/95 sonia_long@norris.com 10/19/95 Norriz Jennifer 614 Harvard Court Carson City 89705 PrintCo 438 Needham Dr. 89510 702-555-4688 702-555-4678uth InfoI CloseJ View As FormK View As ListL ReportsM Your Own Button Information List View Report Menu Sort by Last Name Member List Open Script Dial Home Phone Dial Work Phone Wausau 54401 414-555-9987 12/09/92 11/03/94 v Treasurer w President 05/31/95 12/1/95 11/1/95 10/1/95 05/31/95 11/1/95 10/1/95 9/1/95 ficer 06/24/95 11/1/95 10/1/95 9/1/95 10/19/95 Winford 5905 Brunswick Ave. ` Green Bay 54321 The Framery 715-555-9987 12/09/92 11/03/94 v Treasurer w President 05/31/95 11/1/95 10/1/95 9/1/95 Winford 5905 Brunswick Ave. ` Green Bay 54321 The Framery 715-555-9987 12/09/92 11/03/94 v Treasurer w President 05/31/95 11/1/95 10/1/95 9/1/95 5-555-9987 12/09/92 11/03/94 v Treasurer w President 05/31/95 11/1/95 10/1/95 9/1/95 Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif Modern Sort by Last Name Member List Open Script Dial Home Phone Cancel Specify Field Use Dialing Preferences Phone Number Field Value Number Dial Work Phone Cancel Specify Field Use Dialing Preferences Phone Number Field Value Number A List View Report Menu Information )=400 Cancel </ ? ?< F/ ? ?< You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel </ ? ?< F/ ? ?< No records match this request.E+ ) = 1 wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ UUUUU JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww iiiimm wwwwww UUUUUU DDDDDD """""" 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 11/20/95 Sonia 88 Liberty St. Groton 01450 Norris Corporation 690 Compton Pl. Concord 01742 508-555-6899 508-555-9900 05/03/94 Julie Davidson 05/07/95 12/1/95 11/1/95 10/1/95 sonia_long@norris.com 11/20/95 Norriz Jennifer 614 Harvard Court Carson City 89705 PrintCo 438 Needham Dr. 89510 702-555-4688 702-555-4678 Julie Davidson 05/07/95 11/1/95 10/1/95 9/1/95 sonia_long@norris.com 10/19/95 Norriz Jennifer 614 Harvard Court Carson City 89705 PrintCo 438 Needham Dr. 89510 702-555-4688 702-555-4678 04/05/95 word of mouth 06/04/95 12/1/95 11/1/95 10/1/95 11/20/95 Smith Dennis 88 Liberty St. ` Northside 36304 ACME Accessories 1234 West St. Dothan 36301 205-555-9876 205-555-9010 12/03/94 06/08/95 12/1/95 11/1/95 10/1/95 dsmith@acme.com 11/20/95 Smith Jeremy 912 Darton Blvd. Eugene 97403 Smith's More Corp. 900 Commonwealth Ave. Eugene 97403 503-555-4655 11/05/94 word of mouth 06/13/95 12/1/95 11/1/95 10/1/95 11/20/95 St. Lorant Michael 6711 Main St. San Francisco 94115 Davis & Davis 33 Portola St. San Francisco 94115 415-555-0143 415-555-0177 11/04/92 Vice President Membership Officer 06/24/95 12/1/95 11/1/95 10/1/95 11/20/95 Winford 5905 Brunswick Ave. ` Green Bay 54304 The Framery 79 Boylston Ave.